<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Sort Document dialog box</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
p.whs2 { margin-left:40px; }
ul.whs3 { list-style:square; }
p.whs4 { margin-left:80px; }
ol.whs5 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nInterfaces for working with documents\nSort Document dialog box\nSort Document dialog box");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Sort Document dialog box</h1>
<p>The Sorting dialog box allows you to sort the data for the Grouping 
 and Detail sections of a document. You can select what objects to sort, 
 the sorting criteria (for example, the attribute form on which to sort), 
 and the sorting order (ascending or descending). </p>
<h2>To access the Sort Document dialog box</h2>
<p>From the <span style="font-weight: bold;"><B>Data</B></span> menu, select <span 
 style="font-weight: bold;"><B>Sort Document</B></span>.</p>
<h2>Sort Document dialog box layout</h2>
<ul type="disc" class="whs1">
	
<li class=p><p><span style="font-weight: bold;"><B>Grouping</B></span>: When 
 a grouping has been defined, it is automatically displayed here. You cannot 
 add an additional sort for the grouping section. Grouping items are sorted 
 in the order they appear in the Grouping panel. To change that order, 
 rearrange the objects in the Grouping panel. From the drop-down list, 
 specify what the object is sorted by, depending on whether it is an attribute, 
 a custom group, or a consolidation. For more information, please refer 
 to 
<a HREF="Sorting_grouping_fields.htm">Sorting grouping fields</a>.</p></li>
	
<li class=p><p class="whs2">If you are sorting on an 
 attribute, you can choose which attribute form to sort on. The form does 
 not have to be displayed on the report. </p></li>
	
<li class=p><p class="whs2">If you are sorting on a custom 
 group, you can select from the following options: </p></li>
	<ul type="square" class="whs3">
		
<li class=p><p class="whs2"><span style="font-weight: bold;"><B>Default</B></span> 
 inherits the sort property of the custom group. </p></li>
		
<li class=p><p class="whs2"><span style="font-weight: bold;"><B>Top</B></span> 
 displays the element name first, then its individual items. </p></li>
		
<li class=p><p class="whs2"><span style="font-weight: bold;"><B>Bottom</B></span> 
 displays the individual items of an element, followed by the element name.<span 
 style="font-weight: bold;"><B><br>

		<br>

		Note</B></span>: These options affect the document only if the custom 
 group is displayed as &quot;Show only the individual items within this 
 element and also, expand these individual items if possible&quot; or &quot;Show 
 element names, individual items within this element and also, expand these 
 individual items if possible&quot;. </p></li>
	</ul>
	
<li class=p><p class="whs2">If you are sorting on a consolidation, 
 you cannot adjust the criteria for the sort. It is set at <span style="font-weight: bold;"><B>Default</B></span>. 
 </p></li>
</ul>
<p class="whs2">Select <span style="font-weight: bold;"><B>Ascending</B></span> 
 or <span style="font-weight: bold;"><B>Descending</B></span> to specify the order 
 of the sort. However, you cannot change the Order if the object is a custom 
 group or if the Criteria of an attribute is set to Default. </p>
<ul type="disc" class="whs1">
	
<li class=p><p><span style="font-weight: bold;"><B>Detail</B></span>: Sorting 
 is not automatically defined for the Detail section of a document. You 
 can select any desired object as long as it is in the primary dataset, 
 regardless of where or whether it is placed on the document. Unlike grouping, 
 you can select a metric as a Sort by object.</p></li>
	<ul type="square" class="whs3">
		
<li class=p><p>From the <span style="font-weight: bold;"><B>Sort By</B></span> 
 drop-down list, specify the object on which to sort first. The list contains 
 all the objects in the primary dataset, regardless of where or whether 
 they are placed on the document. </p></li>
		
<li class=p><p>From the <span style="font-weight: bold;"><B>Then By</B></span> 
 drop-down lists, choose additional objects on which to sort. These objects 
 are sorted after the Sort by object.</p></li>
	</ul>
</ul>
<p class="whs4"><span style="font-weight: bold;"><B>Note</B></span>: 
 You can define the sorting order by using up to three objects, if you 
 have multiple objects listed. For more information, please refer to 
<a 
 href="Sort_document.htm">Sorting data in a document</a>.</p>
<ol type="disc" class="whs5">
	<ul type="square" class="whs3">
		
<li class=p><p>Select <span style="font-weight: bold;"><B>Ascending</B></span> 
 or <span style="font-weight: bold;"><B>Descending</B></span> to specify the order 
 of the sort.</p></li>
	</ul>
</ol>
<p class="whs2">&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
